SUBSTITUTE 函數

The Excel REPLACE function replaces characters specified by location in a given text string with another text string. For example =REPLACE(XYZ123,4,3,456) ...

The Excel SUBSTITUTE function can replace text by matching. Use the SUBSTITUTE function when you want to replace text based on matching, not position.

2024年2月28日 — Replacing characters in text with the REPLACE function · Step 1: Old text · Step 2: Start num · Step 3: Num chars · Step 4: New text.

The REPLACE function is categorized under Excel TEXT functions. The function will replace part of a text string, based on the number of characters you ...

語法：REPLACE (old_text、start_num、num_chars、new_text) REPLACEB (old_text、start_num、num_bytes、new_text)

Use SUBSTITUTE when you want to replace specific text in a text string; use REPLACE when you want to replace any text that occurs in a specific location in a ...

將文字字串中的old_text 部分以new_text 取代。 要取代文字字串中的特定字串時，可以使用SUBSTITUTE；若要取代文字字串中特定位置上的任何字串，請使用REPLACE。

2023年3月21日 — Using Excel REPLACE function with numeric values ; =REPLACE(A2, 7, 4, 2016) Replacing numeric characters that are part of a text string ; And ...